----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  F:/Dropbox (UBC-Umich)/Research_Projects/Project Javier and Natalia/TFP firm/TFP_firm_data_historical/dataverse_files/code/logs/table_05_additional_robustness.log
  log type:  text
 opened on:  14 Nov 2022, 10:26:19

. *-------------------------------------------------------------------------------
. 
. 
. *Notice that aggregates are only for countries with DA dummies in more than 10 sectors. A DA for a sector is calculated if at least 3 affiliates operate in that coutry-sector p
> air
. *minimum number of sectors allowed per year-isocode*
. local nn=10 

. 
. foreach rsample in "tax_ratio" "BTT" "gdpdiff" "nogravity" "exclnomark" "ctte" "aboveage10" {
  2. display "`rsample'"
  3. clear all  
  4. use "${data}/estimates_sec_naics_sales_s1_base_woparent_`rsample'.dta", clear
  5. by year isocode, sort: egen num=count( fe_location )
  6. table isocode year, c(mean  num)
  7. keep if num>=`nn'
  8. keep year isocode
  9. duplicates drop 
 10. tempfile iso
 11. save `iso', replace 
 12. 
. use "${data}/estimates_agg_naics_sales_s1_base_woparent_`rsample'.dta", clear
 13. merge m:1 year isocode using `iso'
 14. keep if _merge==3
 15. drop _merge
 16. tempfile file_`rsample'
 17. save `file_`rsample'', replace 
 18. }
tax_ratio

----------------
          | year
  isocode | 2016
----------+-----
       AT |   17
       BE |   19
       BG |   17
       CZ |   18
       DE |   19
       DK |   18
       EE |   17
       ES |   18
       FI |   18
       FR |   18
       GB |   18
       GR |   17
       HR |   17
       HU |   18
       IT |   18
       JP |   15
       KR |   17
       LT |   17
       LV |   17
       MX |   15
       NL |   18
       PL |   18
       PT |   18
       RO |   19
       SE |   19
       SI |   18
       SK |   18
----------------
(0 observations deleted)

Duplicates in terms of all variables

(450 observations deleted)
(note: file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000001.tmp not found)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000001.tmp saved

    Result                           # of obs.
    -----------------------------------------
    not matched                             0
    matched                                27  (_merge==3)
    -----------------------------------------
(0 observations deleted)
(note: file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000002.tmp not found)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000002.tmp saved
BTT

----------------
          | year
  isocode | 2016
----------+-----
       AT |   17
       BE |   19
       BG |   17
       CZ |   18
       DE |   19
       DK |   18
       EE |   17
       ES |   18
       FI |   18
       FR |   18
       GB |   18
       GR |   17
       HR |   17
       HU |   18
       IT |   18
       JP |   15
       KR |   17
       LT |   17
       LV |   17
       MX |   15
       NL |   18
       PL |   18
       PT |   18
       RO |   19
       SE |   19
       SI |   18
       SK |   18
----------------
(0 observations deleted)

Duplicates in terms of all variables

(450 observations deleted)
(note: file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000003.tmp not found)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000003.tmp saved

    Result                           # of obs.
    -----------------------------------------
    not matched                             0
    matched                                27  (_merge==3)
    -----------------------------------------
(0 observations deleted)
(note: file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000004.tmp not found)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000004.tmp saved
gdpdiff

----------------
          | year
  isocode | 2016
----------+-----
       AT |   17
       BE |   19
       BG |   17
       CZ |   18
       DE |   19
       DK |   18
       EE |   17
       ES |   18
       FI |   18
       FR |   18
       GB |   18
       GR |   17
       HR |   17
       HU |   18
       IT |   18
       JP |   15
       KR |   17
       LT |   17
       LV |   17
       MX |   15
       NL |   17
       PL |   18
       PT |   18
       RO |   19
       SE |   19
       SI |   18
       SK |   18
----------------
(0 observations deleted)

Duplicates in terms of all variables

(450 observations deleted)
(note: file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000005.tmp not found)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000005.tmp saved

    Result                           # of obs.
    -----------------------------------------
    not matched                             0
    matched                                27  (_merge==3)
    -----------------------------------------
(0 observations deleted)
(note: file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000006.tmp not found)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000006.tmp saved
nogravity

----------------
          | year
  isocode | 2016
----------+-----
       AT |   17
       BE |   19
       BG |   17
       CZ |   18
       DE |   19
       DK |   18
       EE |   17
       ES |   18
       FI |   18
       FR |   18
       GB |   18
       GR |   17
       HR |   17
       HU |   18
       IT |   18
       JP |   15
       KR |   17
       LT |   17
       LV |   17
       MX |   15
       NL |   18
       PL |   18
       PT |   18
       RO |   19
       SE |   19
       SI |   18
       SK |   18
----------------
(0 observations deleted)

Duplicates in terms of all variables

(450 observations deleted)
(note: file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp not found)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp saved

    Result                           # of obs.
    -----------------------------------------
    not matched                             0
    matched                                27  (_merge==3)
    -----------------------------------------
(0 observations deleted)
(note: file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000008.tmp not found)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000008.tmp saved
exclnomark

----------------
          | year
  isocode | 2016
----------+-----
       AT |   14
       BE |   15
       BG |   15
       CZ |   15
       DE |   15
       DK |   15
       EE |   15
       ES |   15
       FI |   15
       FR |   15
       GB |   15
       GR |   15
       HR |   15
       HU |   15
       IT |   15
       JP |   13
       KR |   15
       LT |   15
       LV |   15
       MX |   15
       NL |   15
       PL |   15
       PT |   15
       RO |   15
       SE |   15
       SI |   15
       SK |   15
----------------
(0 observations deleted)

Duplicates in terms of all variables

(375 observations deleted)
(note: file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000009.tmp not found)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000009.tmp saved

    Result                           # of obs.
    -----------------------------------------
    not matched                             0
    matched                                27  (_merge==3)
    -----------------------------------------
(0 observations deleted)
(note: file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_00000a.tmp not found)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_00000a.tmp saved
ctte

----------------
          | year
  isocode | 2016
----------+-----
       AT |   16
       BE |   18
       BG |   17
       CZ |   18
       DE |   18
       EE |   17
       ES |   18
       FI |   18
       FR |   18
       GB |   18
       GR |   17
       HR |   17
       HU |   18
       IT |   18
       JP |    7
       KR |   15
       LT |   17
       LV |   17
       MX |    1
       NL |   17
       PL |   18
       PT |   18
       RO |   19
       SE |   19
       SI |   18
       SK |   18
----------------
(8 observations deleted)

Duplicates in terms of all variables

(399 observations deleted)
(note: file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_00000b.tmp not found)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_00000b.tmp saved

    Result                           # of obs.
    -----------------------------------------
    not matched                             2
        from master                         2  (_merge==1)
        from using                          0  (_merge==2)

    matched                                24  (_merge==3)
    -----------------------------------------
(2 observations deleted)
(note: file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_00000c.tmp not found)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_00000c.tmp saved
aboveage10

----------------
          | year
  isocode | 2016
----------+-----
       AT |   16
       BE |   19
       BG |   17
       CZ |   18
       DE |   18
       DK |   18
       EE |   17
       ES |   18
       FI |   18
       FR |   18
       GB |   18
       GR |   17
       HR |   17
       HU |   18
       IT |   18
       JP |   13
       KR |   16
       LT |   17
       LV |   17
       MX |   15
       NL |   18
       PL |   18
       PT |   18
       RO |   18
       SE |   18
       SI |   18
       SK |   18
----------------
(0 observations deleted)

Duplicates in terms of all variables

(443 observations deleted)
(note: file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_00000d.tmp not found)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_00000d.tmp saved

    Result                           # of obs.
    -----------------------------------------
    not matched                             0
    matched                                27  (_merge==3)
    -----------------------------------------
(0 observations deleted)
(note: file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_00000e.tmp not found)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_00000e.tmp saved

. 
. foreach rsample in naics4 {
  2. display "`rsample'"
  3. clear all  
  4. use "${data}/estimates_sec_`rsample'_sales_s1_base_woparent.dta", clear
  5. by year isocode, sort: egen num=count( fe_location )
  6. table isocode year, c(mean  num)
  7. keep if num>=`nn'
  8. keep year isocode
  9. duplicates drop 
 10. tempfile iso
 11. save `iso', replace 
 12. 
. use "${data}/estimates_agg_`rsample'_sales_s1_base_woparent.dta", clear
 13. merge m:1 year isocode using `iso'
 14. keep if _merge==3
 15. drop _merge
 16. tempfile file_`rsample'
 17. save `file_`rsample'', replace 
 18. }
naics4

----------------
          | year
  isocode | 2016
----------+-----
       AT |   17
       BE |   19
       BG |   17
       CZ |   18
       DE |   19
       DK |   18
       EE |   17
       ES |   18
       FI |   18
       FR |   18
       GB |   18
       GR |   17
       HR |   17
       HU |   18
       IT |   18
       JP |   15
       KR |   17
       LT |   17
       LV |   17
       MX |   15
       NL |   18
       PL |   18
       PT |   18
       RO |   19
       SE |   19
       SI |   18
       SK |   18
----------------
(0 observations deleted)

Duplicates in terms of all variables

(450 observations deleted)
(note: file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_00000f.tmp not found)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_00000f.tmp saved

    Result                           # of obs.
    -----------------------------------------
    not matched                             0
    matched                                27  (_merge==3)
    -----------------------------------------
(0 observations deleted)
(note: file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_00000g.tmp not found)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_00000g.tmp saved

. 
. 
. 
. *Merging the different samples
. *-----------------------------------------------------------------
. clear all

. use year isocode type D_A using "${data}/estimates_agg_naics_sales_s1_base_woparent.dta", clear

. rename D_A D_A_baseline

. 
. foreach rsample in tax_ratio BTT gdpdiff nogravity exclnomark ctte aboveage10 naics4 {
  2. display "`rsample'"
  3. merge 1:1 year isocode type using `file_`rsample'', keepusing(D_A*)
  4. rename D_A D_A_`rsample'
  5. drop _merge
  6. }
tax_ratio

    Result                           # of obs.
    -----------------------------------------
    not matched                             0
    matched                                27  (_merge==3)
    -----------------------------------------
BTT

    Result                           # of obs.
    -----------------------------------------
    not matched                             0
    matched                                27  (_merge==3)
    -----------------------------------------
gdpdiff

    Result                           # of obs.
    -----------------------------------------
    not matched                             0
    matched                                27  (_merge==3)
    -----------------------------------------
nogravity

    Result                           # of obs.
    -----------------------------------------
    not matched                             0
    matched                                27  (_merge==3)
    -----------------------------------------
exclnomark

    Result                           # of obs.
    -----------------------------------------
    not matched                             0
    matched                                27  (_merge==3)
    -----------------------------------------
ctte

    Result                           # of obs.
    -----------------------------------------
    not matched                             3
        from master                         3  (_merge==1)
        from using                          0  (_merge==2)

    matched                                24  (_merge==3)
    -----------------------------------------
aboveage10

    Result                           # of obs.
    -----------------------------------------
    not matched                             0
    matched                                27  (_merge==3)
    -----------------------------------------
naics4

    Result                           # of obs.
    -----------------------------------------
    not matched                             0
    matched                                27  (_merge==3)
    -----------------------------------------

. 
. local grvar0 "gdp_pw_ppp" 

. local grvar1 "" 

. local rr ""

. local var3 "P"

. local yy "2016"

. local yy_ref=`yy'       

. replace year=`yy_ref'
(0 real changes made)

. merge m:1 year isocode type using "${data}/aggregates_tfp_lp_klems_agg.dta" 
(note: variable year was float, now double to accommodate using data's values)
(note: variable isocode was str2, now str32 to accommodate using data's values)
(note: variable type was str5, now str9 to accommodate using data's values)

    Result                           # of obs.
    -----------------------------------------
    not matched                         2,985
        from master                         0  (_merge==1)
        from using                      2,985  (_merge==2)

    matched                                27  (_merge==3)
    -----------------------------------------

. drop if _merge==2
(2,985 observations deleted)

. drop _merge

. 
. foreach var in D_A_baseline D_A_tax_ratio D_A_BTT D_A_gdpdiff D_A_nogravity D_A_exclnomark D_A_ctte D_A_aboveage10 D_A_naics4  {
  2. gen `var'_phi=(-1)*`var'*(0.2)
  3. }
(3 missing values generated)

. 
. 
. 
. *------------------------------------------------------------------------------
. *DA dummies (baseline)
. *------------------------------------------------------------------------------
. local LHS1 D_A_baseline_phi

. local RHS ln_`grvar0'

.         
. reg `LHS1' `RHS'

      Source |       SS           df       MS      Number of obs   =        27
-------------+----------------------------------   F(1, 25)        =     12.07
       Model |  .222837263         1  .222837263   Prob > F        =    0.0019
    Residual |  .461517255        25   .01846069   R-squared       =    0.3256
-------------+----------------------------------   Adj R-squared   =    0.2986
       Total |  .684354518        26  .026321328   Root MSE        =    .13587

-------------------------------------------------------------------------------
D_A_baselin~i |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
--------------+----------------------------------------------------------------
ln_gdp_pw_ppp |   .3378563   .0972438     3.47   0.002     .1375789    .5381337
        _cons |  -.0883848   .0423907    -2.09   0.047    -.1756901   -.0010794
-------------------------------------------------------------------------------

. mat b = e(b)

. mat V = e(V)

. global c0: display %-03.2fc round(b[1,1],0.01)

. global se0: display %-03.2fc round(sqrt(V[1,1]),0.01)

. display $c0
.34

. display $se0
.1

. 
. 
. *------------------------------------------------------------------------------
. *DA dummies controlling for bilateral MNE-specific tax rates 
. *------------------------------------------------------------------------------
. local LHS1 D_A_tax_ratio_phi

. local RHS ln_`grvar0'

.         
. reg `LHS1' `RHS'

      Source |       SS           df       MS      Number of obs   =        27
-------------+----------------------------------   F(1, 25)        =     10.87
       Model |  .219720567         1  .219720567   Prob > F        =    0.0029
    Residual |  .505254664        25  .020210187   R-squared       =    0.3031
-------------+----------------------------------   Adj R-squared   =    0.2752
       Total |  .724975232        26  .027883663   Root MSE        =    .14216

-------------------------------------------------------------------------------
D_A_tax_rat~i |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
--------------+----------------------------------------------------------------
ln_gdp_pw_ppp |   .3354853   .1017474     3.30   0.003     .1259326    .5450379
        _cons |  -.0997255   .0443539    -2.25   0.034    -.1910741   -.0083769
-------------------------------------------------------------------------------

. mat b = e(b)

. mat V = e(V)

. global c1: display %-03.2fc round(b[1,1],0.01)

. global se1: display %-03.2fc round(sqrt(V[1,1]),0.01)

. display $c1
.34

. display $se1
.1

. 
. 
. *------------------------------------------------------------------------------
. *DA dummies controlling for Bilateral Tax Treaties
. *------------------------------------------------------------------------------
. local LHS1  D_A_BTT_phi 

. local RHS ln_`grvar0'

.         
. reg `LHS1' `RHS'

      Source |       SS           df       MS      Number of obs   =        27
-------------+----------------------------------   F(1, 25)        =     12.53
       Model |  .236158649         1  .236158649   Prob > F        =    0.0016
    Residual |  .471214876        25  .018848595   R-squared       =    0.3339
-------------+----------------------------------   Adj R-squared   =    0.3072
       Total |  .707373526        26  .027206674   Root MSE        =    .13729

-------------------------------------------------------------------------------
  D_A_BTT_phi |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
--------------+----------------------------------------------------------------
ln_gdp_pw_ppp |   .3478084   .0982602     3.54   0.002     .1454377     .550179
        _cons |  -.0870706   .0428338    -2.03   0.053    -.1752884    .0011473
-------------------------------------------------------------------------------

. mat b = e(b)

. mat V = e(V)

. global c2: display %-03.2fc round(b[1,1],0.01)

. global se2: display %-03.2fc round(sqrt(V[1,1]),0.01)

. display $c2
.35

. display $se2
.1

. 
. 
. *------------------------------------------------------------------------------
. *DA dummies controlling for differences in GDP per-worker between source and host country
. *------------------------------------------------------------------------------
. local LHS1 D_A_gdpdiff_phi 

. local RHS ln_`grvar0'

.         
. reg `LHS1' `RHS'

      Source |       SS           df       MS      Number of obs   =        27
-------------+----------------------------------   F(1, 25)        =     12.09
       Model |  .218580611         1  .218580611   Prob > F        =    0.0019
    Residual |  .452050503        25   .01808202   R-squared       =    0.3259
-------------+----------------------------------   Adj R-squared   =    0.2990
       Total |  .670631114        26  .025793504   Root MSE        =    .13447

-------------------------------------------------------------------------------
D_A_gdpdiff~i |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
--------------+----------------------------------------------------------------
ln_gdp_pw_ppp |   .3346138   .0962413     3.48   0.002     .1364011    .5328265
        _cons |  -.0897346   .0419537    -2.14   0.042    -.1761399   -.0033293
-------------------------------------------------------------------------------

. mat b = e(b)

. mat V = e(V)

. global c3: display %-03.2fc round(b[1,1],0.01)

. global se3: display %-03.2fc round(sqrt(V[1,1]),0.01)

. display $c3
.33

. display $se3
.1

. 
. 
. *------------------------------------------------------------------------------
. *DA dummies excluding gravity variables 
. *------------------------------------------------------------------------------
. local LHS1 D_A_nogravity_phi

. local RHS ln_`grvar0'

.         
. reg `LHS1' `RHS'

      Source |       SS           df       MS      Number of obs   =        27
-------------+----------------------------------   F(1, 25)        =      7.50
       Model |  .167056385         1  .167056385   Prob > F        =    0.0112
    Residual |  .556739119        25  .022269565   R-squared       =    0.2308
-------------+----------------------------------   Adj R-squared   =    0.2000
       Total |  .723795504        26  .027838289   Root MSE        =    .14923

-------------------------------------------------------------------------------
D_A_nogravi~i |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
--------------+----------------------------------------------------------------
ln_gdp_pw_ppp |   .2925295   .1068056     2.74   0.011     .0725593    .5124997
        _cons |  -.0844221   .0465589    -1.81   0.082    -.1803119    .0114678
-------------------------------------------------------------------------------

. mat b = e(b)

. mat V = e(V)

. global c4: display %-03.2fc round(b[1,1],0.01)

. global se4: display %-03.2fc round(sqrt(V[1,1]),0.01)

. display $c4
.29

. display $se4
.11

. 
. 
. *------------------------------------------------------------------------------
. *DA dummies excluding Real Estate, Health, and Education
. *------------------------------------------------------------------------------
. local LHS1 D_A_exclnomark_phi

. local RHS ln_`grvar0'

.         
. reg `LHS1' `RHS'

      Source |       SS           df       MS      Number of obs   =        27
-------------+----------------------------------   F(1, 25)        =     11.01
       Model |  .204156357         1  .204156357   Prob > F        =    0.0028
    Residual |  .463606068        25  .018544243   R-squared       =    0.3057
-------------+----------------------------------   Adj R-squared   =    0.2780
       Total |  .667762425        26   .02568317   Root MSE        =    .13618

-------------------------------------------------------------------------------
D_A_exclnom~i |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
--------------+----------------------------------------------------------------
ln_gdp_pw_ppp |   .3233847   .0974636     3.32   0.003     .1226546    .5241149
        _cons |  -.0946406   .0424865    -2.23   0.035    -.1821433   -.0071379
-------------------------------------------------------------------------------

. mat b = e(b)

. mat V = e(V)

. global c5: display %-03.2fc round(b[1,1],0.01)

. global se5: display %-03.2fc round(sqrt(V[1,1]),0.01)

. display $c5
.32

. display $se5
.1

. 
. 
. *------------------------------------------------------------------------------
. *DA dummies excluding MNEs that do not appear in ORBIS every year between 2010-2016 (constant sample)
. *------------------------------------------------------------------------------
. local LHS1 D_A_ctte_phi

. local RHS ln_`grvar0'

. 
. reg `LHS1' `RHS'

      Source |       SS           df       MS      Number of obs   =        24
-------------+----------------------------------   F(1, 22)        =     18.53
       Model |  .240070749         1  .240070749   Prob > F        =    0.0003
    Residual |  .285062902        22  .012957405   R-squared       =    0.4572
-------------+----------------------------------   Adj R-squared   =    0.4325
       Total |  .525133651        23  .022831898   Root MSE        =    .11383

-------------------------------------------------------------------------------
 D_A_ctte_phi |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
--------------+----------------------------------------------------------------
ln_gdp_pw_ppp |   .3870787   .0899267     4.30   0.000     .2005821    .5735752
        _cons |  -.0983343   .0383314    -2.57   0.018    -.1778287   -.0188399
-------------------------------------------------------------------------------

. mat b = e(b)

. mat V = e(V)

. global c6: display %-03.2fc round(b[1,1],0.01)

. global se6: display %-03.2fc round(sqrt(V[1,1]),0.01)

. display $c6
.39

. display $se6
.09

. 
. 
. *------------------------------------------------------------------------------
. *DA dummies excluding MNE affiliates incorporated after 2006
. *------------------------------------------------------------------------------
. local LHS1 D_A_aboveage10_phi

. local RHS ln_`grvar0'

. 
. reg `LHS1' `RHS'

      Source |       SS           df       MS      Number of obs   =        27
-------------+----------------------------------   F(1, 25)        =     12.20
       Model |  .208524333         1  .208524333   Prob > F        =    0.0018
    Residual |  .427445145        25  .017097806   R-squared       =    0.3279
-------------+----------------------------------   Adj R-squared   =    0.3010
       Total |  .635969478        26  .024460365   Root MSE        =    .13076

-------------------------------------------------------------------------------
D_A_aboveag~i |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
--------------+----------------------------------------------------------------
ln_gdp_pw_ppp |   .3268259   .0935854     3.49   0.002     .1340831    .5195687
        _cons |  -.0810467    .040796    -1.99   0.058    -.1650676    .0029741
-------------------------------------------------------------------------------

. mat b = e(b)

. mat V = e(V)

. global c7: display %-03.2fc round(b[1,1],0.01)

. global se7: display %-03.2fc round(sqrt(V[1,1]),0.01)

. display $c7
.33

. display $se7
.09

. 
. 
. *------------------------------------------------------------------------------
. *DA dummies for aggregation at 4-digit NAICS industries 
. *------------------------------------------------------------------------------
. local LHS1 D_A_naics4_phi

. local RHS ln_`grvar0'

.         
. reg `LHS1' `RHS'

      Source |       SS           df       MS      Number of obs   =        27
-------------+----------------------------------   F(1, 25)        =     12.97
       Model |  .283871882         1  .283871882   Prob > F        =    0.0014
    Residual |   .54733983        25  .021893593   R-squared       =    0.3415
-------------+----------------------------------   Adj R-squared   =    0.3152
       Total |  .831211711        26  .031969681   Root MSE        =    .14796

-------------------------------------------------------------------------------
D_A_naics4_~i |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
--------------+----------------------------------------------------------------
ln_gdp_pw_ppp |   .3813285   .1059002     3.60   0.001      .163223     .599434
        _cons |  -.1166668   .0461642    -2.53   0.018    -.2117438   -.0215898
-------------------------------------------------------------------------------

. mat b = e(b)

. mat V = e(V)

. global c8: display %-03.2fc round(b[1,1],0.01)

. global se8: display %-03.2fc round(sqrt(V[1,1]),0.01)

. display $c8
.38

. display $se8
.11

.             
. 
.                 
. 
. *------------------------------------------------------------------------------
. *Generate Table 5
. *------------------------------------------------------------------------------
. clear all

. set obs 9
number of observations (_N) was 0, now 9

. 
. gen model=""
(9 missing values generated)

. gen phi_share=. 
(9 missing values generated)

. gen phi_share_se=. 
(9 missing values generated)

. 
. 
. replace model="Baseline" if _n==1
variable model was str1 now str8
(1 real change made)

. replace phi_share=$c0 if _n==1
(1 real change made)

. replace phi_share_se=$se0 if _n==1
(1 real change made)

. 
. replace model="Controlling for tax_ratio" if _n==2
variable model was str8 now str25
(1 real change made)

. replace phi_share=$c1 if _n==2
(1 real change made)

. replace phi_share_se=$se1 if _n==2
(1 real change made)

. 
. replace model="Controlling for BTT" if _n==3
(1 real change made)

. replace phi_share=$c2 if _n==3
(1 real change made)

. replace phi_share_se=$se2 if _n==3
(1 real change made)

. 
. replace model="Controlling for GDP per-worker diff" if _n==4
variable model was str25 now str35
(1 real change made)

. replace phi_share=$c3 if _n==4
(1 real change made)

. replace phi_share_se=$se3 if _n==4
(1 real change made)

. 
. replace model="Excluding gravity var " if _n==5
(1 real change made)

. replace phi_share=$c4 if _n==5
(1 real change made)

. replace phi_share_se=$se4 if _n==5
(1 real change made)

. 
. replace model="Excluding Real Estate, Health, and Education" if _n==6
variable model was str35 now str44
(1 real change made)

. replace phi_share=$c5 if _n==6
(1 real change made)

. replace phi_share_se=$se5 if _n==6
(1 real change made)

. 
. replace model="Excluding MNEs (not every year)" if _n==7
(1 real change made)

. replace phi_share=$c6 if _n==7
(1 real change made)

. replace phi_share_se=$se6 if _n==7
(1 real change made)

. 
. replace model="Excluding MNE affiliates incorporated after 2006" if _n==8
variable model was str44 now str48
(1 real change made)

. replace phi_share=$c7 if _n==8
(1 real change made)

. replace phi_share_se=$se7 if _n==8
(1 real change made)

. 
. replace model="Aggregation at 4-digit NAICS industries " if _n==9
(1 real change made)

. replace phi_share=$c8 if _n==9
(1 real change made)

. replace phi_share_se=$se8 if _n==9
(1 real change made)

. 
. export delimited using "${rmain}/table_05_additional_robustness.csv", datafmt replace
(note: file F:/Dropbox (UBC-Umich)/Research_Projects/Project Javier and Natalia/TFP firm/TFP_firm_data_historical/dataverse_files/results/main/table_05_additional_robustness.csv 
> not found)
file F:/Dropbox (UBC-Umich)/Research_Projects/Project Javier and Natalia/TFP firm/TFP_firm_data_historical/dataverse_files/results/main/table_05_additional_robustness.csv saved

. 
. log close
      name:  <unnamed>
       log:  F:/Dropbox (UBC-Umich)/Research_Projects/Project Javier and Natalia/TFP firm/TFP_firm_data_historical/dataverse_files/code/logs/table_05_additional_robustness.log
  log type:  text
 closed on:  14 Nov 2022, 10:26:20
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
